﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="DS_Rotinas" targetNamespace="http://tempuri.org/DS_Rotinas.xsd" xmlns:mstns="http://tempuri.org/DS_Rotinas.xsd" xmlns="http://tempuri.org/DS_Rotinas.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="miraparkConnectionStringDataSets" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="miraparkConnectionStringDataSets (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.MakeIT.MiraPark.Apresentacao.Properties.Settings.GlobalReference.Default.miraparkConnectionStringDataSets" Provider="MySql.Data.MySqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="alertas_pendentesTableAdapter" GeneratorDataComponentClassName="alertas_pendentesTableAdapter" Name="alertas_pendentes" UserDataComponentName="alertas_pendentesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="miraparkConnectionStringDataSets (Settings)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="GetData">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        alerta.IdAlerta, alerta.IdCliente, alerta.Placa, alerta.Mensagem, alerta.ReterSaida, alerta.ImpedirEntrada, alerta.ApenasComunicar, alerta.Situacao, 
                         cliente.Nome
FROM            alerta LEFT OUTER JOIN
                         cliente ON alerta.IdCliente = cliente.IdCliente
WHERE        (alerta.Situacao = 'Pendente')</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IdAlerta" DataSetColumn="IdAlerta" />
              <Mapping SourceColumn="IdCliente" DataSetColumn="IdCliente" />
              <Mapping SourceColumn="Placa" DataSetColumn="Placa" />
              <Mapping SourceColumn="Mensagem" DataSetColumn="Mensagem" />
              <Mapping SourceColumn="ReterSaida" DataSetColumn="ReterSaida" />
              <Mapping SourceColumn="ImpedirEntrada" DataSetColumn="ImpedirEntrada" />
              <Mapping SourceColumn="ApenasComunicar" DataSetColumn="ApenasComunicar" />
              <Mapping SourceColumn="Situacao" DataSetColumn="Situacao" />
              <Mapping SourceColumn="Nome" DataSetColumn="Nome" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="alertas_executadosTableAdapter" GeneratorDataComponentClassName="alertas_executadosTableAdapter" Name="alertas_executados" UserDataComponentName="alertas_executadosTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="miraparkConnectionStringDataSets (Settings)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="GetData">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        alerta.IdAlerta, alerta.IdCliente, cliente.Nome, alerta.Placa, alerta.Mensagem, alerta.ReterSaida, alerta.ImpedirEntrada, alerta.ApenasComunicar, 
                         alerta.DataExec, alerta.IdCabine, cabine.Cabine
FROM            alerta LEFT OUTER JOIN
                         cabine ON alerta.IdCabine = cabine.IdCabine LEFT OUTER JOIN
                         cliente ON alerta.IdCliente = cliente.IdCliente
WHERE        (alerta.Situacao = 'Executado') AND (alerta.DataExec &gt;= @DataIni) AND (alerta.DataExec &lt;= @DataFim)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="DataIni" ColumnName="DataExec" DataSourceName="mirapark.alerta" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@DataIni" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataExec" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="DataFim" ColumnName="DataExec" DataSourceName="mirapark.alerta" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@DataFim" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataExec" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IdAlerta" DataSetColumn="IdAlerta" />
              <Mapping SourceColumn="IdCliente" DataSetColumn="IdCliente" />
              <Mapping SourceColumn="Nome" DataSetColumn="Nome" />
              <Mapping SourceColumn="Placa" DataSetColumn="Placa" />
              <Mapping SourceColumn="Mensagem" DataSetColumn="Mensagem" />
              <Mapping SourceColumn="ReterSaida" DataSetColumn="ReterSaida" />
              <Mapping SourceColumn="ImpedirEntrada" DataSetColumn="ImpedirEntrada" />
              <Mapping SourceColumn="ApenasComunicar" DataSetColumn="ApenasComunicar" />
              <Mapping SourceColumn="DataExec" DataSetColumn="DataExec" />
              <Mapping SourceColumn="IdCabine" DataSetColumn="IdCabine" />
              <Mapping SourceColumn="Cabine" DataSetColumn="Cabine" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="movimentos_financeiros_cabineTableAdapter" GeneratorDataComponentClassName="movimentos_financeiros_cabineTableAdapter" Name="movimentos_financeiros_cabine" UserDataComponentName="movimentos_financeiros_cabineTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="miraparkConnectionStringDataSets (Settings)" DbObjectName="" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        cabine.IdPatio, patio.Patio, cabinexmovimento.IdCabine, cabine.Cabine, cabinexmovimento.DataMov, cabinexmovimento.Movimento, 
                         cabinexmovimento.Credito, cabinexmovimento.Debito, cabinexmovimento.Saldo
FROM            cabine INNER JOIN
                         cabinexmovimento ON cabine.IdCabine = cabinexmovimento.IdCabine INNER JOIN
                         patio ON cabine.IdPatio = patio.IdPatio
WHERE        (DATE(cabinexmovimento.DataMov) &gt;= @DataIni) AND (DATE(cabinexmovimento.DataMov) &lt;= @DataFim)
ORDER BY cabinexmovimento.DataMov</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="DataIni" ColumnName="DataMov" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@DataIni" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataMov" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="DataFim" ColumnName="DataMov" DataSourceName="" DataTypeServer="datetime" DbType="DateTime" Direction="Input" ParameterName="@DataFim" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="DataMov" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IdPatio" DataSetColumn="IdPatio" />
              <Mapping SourceColumn="Patio" DataSetColumn="Patio" />
              <Mapping SourceColumn="IdCabine" DataSetColumn="IdCabine" />
              <Mapping SourceColumn="Cabine" DataSetColumn="Cabine" />
              <Mapping SourceColumn="DataMov" DataSetColumn="DataMov" />
              <Mapping SourceColumn="Movimento" DataSetColumn="Movimento" />
              <Mapping SourceColumn="Credito" DataSetColumn="Credito" />
              <Mapping SourceColumn="Debito" DataSetColumn="Debito" />
              <Mapping SourceColumn="Saldo" DataSetColumn="Saldo" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="recebimentoTableAdapter" GeneratorDataComponentClassName="recebimentoTableAdapter" Name="recebimento" UserDataComponentName="recebimentoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="miraparkConnectionStringDataSets (Settings)" DbObjectName="mirapark.formapagamento" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        formapagamento.IdFormaPagamento, formapagamento.FormaPagamento, SUM(recebimento.Valor) AS Valor, SUM(recebimento.ValorRec) AS ValorRec
FROM            recebimento LEFT OUTER JOIN
                         formapagamento ON recebimento.IdFormaPagamento = formapagamento.IdFormaPagamento
WHERE        (recebimento.DtPagamento &gt;= @DatIni) AND (recebimento.DtPagamento &lt;= @DatFim)
GROUP BY formapagamento.IdFormaPagamento, formapagamento.FormaPagamento</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="DatIni" ColumnName="DtPagamento" DataSourceName="mirapark.recebimento" DataTypeServer="date" DbType="DateTime" Direction="Input" ParameterName="@DatIni" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DtPagamento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="DatFim" ColumnName="DtPagamento" DataSourceName="mirapark.recebimento" DataTypeServer="date" DbType="DateTime" Direction="Input" ParameterName="@DatFim" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DtPagamento" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IdFormaPagamento" DataSetColumn="IdFormaPagamento" />
              <Mapping SourceColumn="FormaPagamento" DataSetColumn="FormaPagamento" />
              <Mapping SourceColumn="Valor" DataSetColumn="Valor" />
              <Mapping SourceColumn="ValorRec" DataSetColumn="ValorRec" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="recebimentoAbertoTableAdapter" GeneratorDataComponentClassName="recebimentoAbertoTableAdapter" Name="recebimentoAberto" UserDataComponentName="recebimentoAbertoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="miraparkConnectionStringDataSets (Settings)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="GetData">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        recebimento.IdRecebimento, recebimento.Recebimento, recebimento.IdConvenio, cliente_convenio.Nome AS NomeConvenio, recebimento.IdMensalista, 
                         cliente_mensalista.Nome AS NomeMensalista, recebimento.DtVencimento, recebimento.Valor
FROM            mensalista INNER JOIN
                         cliente cliente_mensalista ON mensalista.IdCliente = cliente_mensalista.IdCliente RIGHT OUTER JOIN
                         recebimento ON recebimento.IdMensalista = mensalista.IdMensalista LEFT OUTER JOIN
                         cliente cliente_convenio INNER JOIN
                         convenio ON cliente_convenio.IdCliente = convenio.IdCliente ON recebimento.IdConvenio = convenio.IdConvenio
WHERE        (recebimento.DtPagamento IS NULL)
ORDER BY recebimento.DtVencimento</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IdRecebimento" DataSetColumn="IdRecebimento" />
              <Mapping SourceColumn="Recebimento" DataSetColumn="Recebimento" />
              <Mapping SourceColumn="IdConvenio" DataSetColumn="IdConvenio" />
              <Mapping SourceColumn="NomeConvenio" DataSetColumn="NomeConvenio" />
              <Mapping SourceColumn="IdMensalista" DataSetColumn="IdMensalista" />
              <Mapping SourceColumn="NomeMensalista" DataSetColumn="NomeMensalista" />
              <Mapping SourceColumn="DtVencimento" DataSetColumn="DtVencimento" />
              <Mapping SourceColumn="Valor" DataSetColumn="Valor" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="recebimentoConvenioTableAdapter" GeneratorDataComponentClassName="recebimentoConvenioTableAdapter" Name="recebimentoConvenio" UserDataComponentName="recebimentoConvenioTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="miraparkConnectionStringDataSets (Settings)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="GetData">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        recebimento.IdRecebimento, recebimento.Recebimento, recebimento.IdConvenio, cliente_convenio.Nome AS NomeConvenio, recebimento.DtVencimento, 
                         recebimento.DtPagamento, recebimento.IdFormaPagamento, formapagamento.FormaPagamento, recebimento.Valor, recebimento.ValorRec
FROM            recebimento LEFT OUTER JOIN
                         formapagamento ON recebimento.IdFormaPagamento = formapagamento.IdFormaPagamento LEFT OUTER JOIN
                         cliente cliente_convenio INNER JOIN
                         convenio ON cliente_convenio.IdCliente = convenio.IdCliente ON recebimento.IdConvenio = convenio.IdConvenio
WHERE        (recebimento.DtPagamento &gt;= @DatIni) AND (recebimento.DtPagamento &lt;= @DatFim) AND (recebimento.IdConvenio &lt;&gt; -1)
ORDER BY recebimento.DtVencimento</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="DatIni" ColumnName="DtPagamento" DataSourceName="mirapark.recebimento" DataTypeServer="date" DbType="DateTime" Direction="Input" ParameterName="@DatIni" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DtPagamento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="DatFim" ColumnName="DtPagamento" DataSourceName="mirapark.recebimento" DataTypeServer="date" DbType="DateTime" Direction="Input" ParameterName="@DatFim" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DtPagamento" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IdRecebimento" DataSetColumn="IdRecebimento" />
              <Mapping SourceColumn="Recebimento" DataSetColumn="Recebimento" />
              <Mapping SourceColumn="IdConvenio" DataSetColumn="IdConvenio" />
              <Mapping SourceColumn="NomeConvenio" DataSetColumn="NomeConvenio" />
              <Mapping SourceColumn="DtVencimento" DataSetColumn="DtVencimento" />
              <Mapping SourceColumn="Valor" DataSetColumn="Valor" />
              <Mapping SourceColumn="DtPagamento" DataSetColumn="DtPagamento" />
              <Mapping SourceColumn="IdFormaPagamento" DataSetColumn="IdFormaPagamento" />
              <Mapping SourceColumn="FormaPagamento" DataSetColumn="FormaPagamento" />
              <Mapping SourceColumn="ValorRec" DataSetColumn="ValorRec" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="recebimentoMensalistaTableAdapter" GeneratorDataComponentClassName="recebimentoMensalistaTableAdapter" Name="recebimentoMensalista" UserDataComponentName="recebimentoMensalistaTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="miraparkConnectionStringDataSets (Settings)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="GetData">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        recebimento.IdRecebimento, recebimento.Recebimento, recebimento.IdMensalista, cliente_mensalista.Nome, recebimento.DtVencimento, 
                         recebimento.DtPagamento, recebimento.Valor, recebimento.ValorRec, recebimento.IdFormaPagamento, formapagamento.FormaPagamento
FROM            cliente cliente_mensalista INNER JOIN
                         mensalista ON cliente_mensalista.IdCliente = mensalista.IdCliente RIGHT OUTER JOIN
                         recebimento ON mensalista.IdMensalista = recebimento.IdMensalista LEFT OUTER JOIN
                         formapagamento ON recebimento.IdFormaPagamento = formapagamento.IdFormaPagamento
WHERE        (recebimento.DtPagamento &gt;= @DatIni) AND (recebimento.DtPagamento &lt;= @DatFim) AND (recebimento.IdMensalista &lt;&gt; - 1)
ORDER BY recebimento.DtVencimento</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="DatIni" ColumnName="DtPagamento" DataSourceName="mirapark.recebimento" DataTypeServer="date" DbType="DateTime" Direction="Input" ParameterName="@DatIni" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DtPagamento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="DatFim" ColumnName="DtPagamento" DataSourceName="mirapark.recebimento" DataTypeServer="date" DbType="DateTime" Direction="Input" ParameterName="@DatFim" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DtPagamento" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IdRecebimento" DataSetColumn="IdRecebimento" />
              <Mapping SourceColumn="Recebimento" DataSetColumn="Recebimento" />
              <Mapping SourceColumn="DtVencimento" DataSetColumn="DtVencimento" />
              <Mapping SourceColumn="Valor" DataSetColumn="Valor" />
              <Mapping SourceColumn="DtPagamento" DataSetColumn="DtPagamento" />
              <Mapping SourceColumn="IdFormaPagamento" DataSetColumn="IdFormaPagamento" />
              <Mapping SourceColumn="FormaPagamento" DataSetColumn="FormaPagamento" />
              <Mapping SourceColumn="ValorRec" DataSetColumn="ValorRec" />
              <Mapping SourceColumn="IdMensalista" DataSetColumn="IdMensalista" />
              <Mapping SourceColumn="Nome" DataSetColumn="Nome" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="recebimentoDiversosTableAdapter" GeneratorDataComponentClassName="recebimentoDiversosTableAdapter" Name="recebimentoDiversos" UserDataComponentName="recebimentoDiversosTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="miraparkConnectionStringDataSets (Settings)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="GetData">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        recebimento.IdRecebimento, recebimento.Recebimento, Count(*) AS Qtde, Sum(recebimento.Valor) AS Valor, Sum(recebimento.ValorRec) as ValorRec, recebimento.IdFormaPagamento, 
                         formapagamento.FormaPagamento
FROM            recebimento LEFT OUTER JOIN
                         formapagamento ON recebimento.IdFormaPagamento = formapagamento.IdFormaPagamento
WHERE        (recebimento.DtPagamento &gt;= @DatIni) AND (recebimento.DtPagamento &lt;= @DatFim) AND (recebimento.IdMensalista = - 1) AND 
                         (recebimento.IdConvenio = - 1)
GROUP BY recebimento.Recebimento, recebimento.IdFormaPagamento</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="DatIni" ColumnName="DtPagamento" DataSourceName="mirapark.recebimento" DataTypeServer="date" DbType="DateTime" Direction="Input" ParameterName="@DatIni" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DtPagamento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="DatFim" ColumnName="DtPagamento" DataSourceName="mirapark.recebimento" DataTypeServer="date" DbType="DateTime" Direction="Input" ParameterName="@DatFim" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DtPagamento" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IdRecebimento" DataSetColumn="IdRecebimento" />
              <Mapping SourceColumn="Recebimento" DataSetColumn="Recebimento" />
              <Mapping SourceColumn="Valor" DataSetColumn="Valor" />
              <Mapping SourceColumn="IdFormaPagamento" DataSetColumn="IdFormaPagamento" />
              <Mapping SourceColumn="FormaPagamento" DataSetColumn="FormaPagamento" />
              <Mapping SourceColumn="ValorRec" DataSetColumn="ValorRec" />
              <Mapping SourceColumn="Qtde" DataSetColumn="Qtde" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="pagamentoTableAdapter" GeneratorDataComponentClassName="pagamentoTableAdapter" Name="pagamento" UserDataComponentName="pagamentoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="miraparkConnectionStringDataSets (Settings)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="GetData">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        pagamento.IdPagamento, pagamento.Pagamento, pagamento.DtVencimento, pagamento.DtPagamento, pagamento.IdFormaPagamento, pagamento.Valor, 
                         pagamento.ValorPago, formapagamento.FormaPagamento
FROM            pagamento LEFT OUTER JOIN
                         formapagamento ON pagamento.IdFormaPagamento = formapagamento.IdFormaPagamento
WHERE        (pagamento.DtPagamento &gt;= @DatIni) AND (pagamento.DtPagamento &lt;= @DatFim)
ORDER BY pagamento.DtPagamento</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="DatIni" ColumnName="DtPagamento" DataSourceName="mirapark.pagamento" DataTypeServer="date" DbType="DateTime" Direction="Input" ParameterName="@DatIni" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DtPagamento" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="DatFim" ColumnName="DtPagamento" DataSourceName="mirapark.pagamento" DataTypeServer="date" DbType="DateTime" Direction="Input" ParameterName="@DatFim" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="DtPagamento" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IdPagamento" DataSetColumn="IdPagamento" />
              <Mapping SourceColumn="Pagamento" DataSetColumn="Pagamento" />
              <Mapping SourceColumn="DtVencimento" DataSetColumn="DtVencimento" />
              <Mapping SourceColumn="DtPagamento" DataSetColumn="DtPagamento" />
              <Mapping SourceColumn="IdFormaPagamento" DataSetColumn="IdFormaPagamento" />
              <Mapping SourceColumn="Valor" DataSetColumn="Valor" />
              <Mapping SourceColumn="ValorPago" DataSetColumn="ValorPago" />
              <Mapping SourceColumn="FormaPagamento" DataSetColumn="FormaPagamento" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="pagamentoAbertoTableAdapter" GeneratorDataComponentClassName="pagamentoAbertoTableAdapter" Name="pagamentoAberto" UserDataComponentName="pagamentoAbertoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="miraparkConnectionStringDataSets (Settings)" DbObjectName="mirapark.pagamento" DbObjectType="Table" GenerateMethods="Get" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="GetData">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        IdPagamento, Pagamento, DtVencimento, Valor
FROM            pagamento
WHERE        (DtPagamento IS NULL) 
ORDER BY DtPagamento</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IdPagamento" DataSetColumn="IdPagamento" />
              <Mapping SourceColumn="Pagamento" DataSetColumn="Pagamento" />
              <Mapping SourceColumn="DtVencimento" DataSetColumn="DtVencimento" />
              <Mapping SourceColumn="Valor" DataSetColumn="Valor" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="pendenciaAbertoTableAdapter" GeneratorDataComponentClassName="pendenciaAbertoTableAdapter" Name="pendenciaAberto" UserDataComponentName="pendenciaAbertoTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="miraparkConnectionStringDataSets (Settings)" DbObjectType="Unknown" GenerateMethods="Get" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="GetData">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        pendencia.IdPendencia, pendencia.Pendencia, pendencia.IdOperador, usuario.Nome, pendencia.Placa, pendencia.Valor
FROM            pendencia LEFT OUTER JOIN
                         usuario ON pendencia.IdOperador = usuario.IdUsuario
WHERE        (pendencia.DtPagamento IS NULL)
ORDER BY pendencia.IdPendencia</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="IdPendencia" DataSetColumn="IdPendencia" />
              <Mapping SourceColumn="Pendencia" DataSetColumn="Pendencia" />
              <Mapping SourceColumn="IdOperador" DataSetColumn="IdOperador" />
              <Mapping SourceColumn="Nome" DataSetColumn="Nome" />
              <Mapping SourceColumn="Placa" DataSetColumn="Placa" />
              <Mapping SourceColumn="Valor" DataSetColumn="Valor" />
            </Mappings>
            <Sources />
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="DS_Rotinas" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="DS_Rotinas" msprop:Generator_DataSetName="DS_Rotinas" msprop:EnableTableAdapterManager="True">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="alertas_pendentes" msprop:Generator_UserTableName="alertas_pendentes" msprop:Generator_RowDeletedName="alertas_pendentesRowDeleted" msprop:Generator_RowChangedName="alertas_pendentesRowChanged" msprop:Generator_RowClassName="alertas_pendentesRow" msprop:Generator_RowChangingName="alertas_pendentesRowChanging" msprop:Generator_RowEvArgName="alertas_pendentesRowChangeEvent" msprop:Generator_RowEvHandlerName="alertas_pendentesRowChangeEventHandler" msprop:Generator_TableClassName="alertas_pendentesDataTable" msprop:Generator_TableVarName="tablealertas_pendentes" msprop:Generator_RowDeletingName="alertas_pendentesRowDeleting" msprop:Generator_TablePropName="alertas_pendentes">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IdAlerta" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="IdAlerta" msprop:Generator_ColumnVarNameInTable="columnIdAlerta" msprop:Generator_ColumnPropNameInRow="IdAlerta" msprop:Generator_ColumnPropNameInTable="IdAlertaColumn" type="xs:int" />
              <xs:element name="IdCliente" msprop:Generator_UserColumnName="IdCliente" msprop:Generator_ColumnVarNameInTable="columnIdCliente" msprop:Generator_ColumnPropNameInRow="IdCliente" msprop:Generator_ColumnPropNameInTable="IdClienteColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Placa" msprop:Generator_UserColumnName="Placa" msprop:Generator_ColumnVarNameInTable="columnPlaca" msprop:Generator_ColumnPropNameInRow="Placa" msprop:Generator_ColumnPropNameInTable="PlacaColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Mensagem" msprop:Generator_UserColumnName="Mensagem" msprop:Generator_ColumnVarNameInTable="columnMensagem" msprop:Generator_ColumnPropNameInRow="Mensagem" msprop:Generator_ColumnPropNameInTable="MensagemColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ReterSaida" msprop:Generator_UserColumnName="ReterSaida" msprop:Generator_ColumnVarNameInTable="columnReterSaida" msprop:Generator_ColumnPropNameInRow="ReterSaida" msprop:Generator_ColumnPropNameInTable="ReterSaidaColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="ImpedirEntrada" msprop:Generator_UserColumnName="ImpedirEntrada" msprop:Generator_ColumnVarNameInTable="columnImpedirEntrada" msprop:Generator_ColumnPropNameInRow="ImpedirEntrada" msprop:Generator_ColumnPropNameInTable="ImpedirEntradaColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="ApenasComunicar" msprop:Generator_UserColumnName="ApenasComunicar" msprop:Generator_ColumnVarNameInTable="columnApenasComunicar" msprop:Generator_ColumnPropNameInRow="ApenasComunicar" msprop:Generator_ColumnPropNameInTable="ApenasComunicarColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="Situacao" msprop:Generator_UserColumnName="Situacao" msprop:Generator_ColumnVarNameInTable="columnSituacao" msprop:Generator_ColumnPropNameInRow="Situacao" msprop:Generator_ColumnPropNameInTable="SituacaoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Nome" msprop:Generator_UserColumnName="Nome" msprop:Generator_ColumnVarNameInTable="columnNome" msprop:Generator_ColumnPropNameInRow="Nome" msprop:Generator_ColumnPropNameInTable="NomeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="alertas_executados" msprop:Generator_UserTableName="alertas_executados" msprop:Generator_RowDeletedName="alertas_executadosRowDeleted" msprop:Generator_RowChangedName="alertas_executadosRowChanged" msprop:Generator_RowClassName="alertas_executadosRow" msprop:Generator_RowChangingName="alertas_executadosRowChanging" msprop:Generator_RowEvArgName="alertas_executadosRowChangeEvent" msprop:Generator_RowEvHandlerName="alertas_executadosRowChangeEventHandler" msprop:Generator_TableClassName="alertas_executadosDataTable" msprop:Generator_TableVarName="tablealertas_executados" msprop:Generator_RowDeletingName="alertas_executadosRowDeleting" msprop:Generator_TablePropName="alertas_executados">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IdAlerta" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="IdAlerta" msprop:Generator_ColumnPropNameInRow="IdAlerta" msprop:Generator_ColumnVarNameInTable="columnIdAlerta" msprop:Generator_ColumnPropNameInTable="IdAlertaColumn" type="xs:int" />
              <xs:element name="IdCliente" msprop:Generator_UserColumnName="IdCliente" msprop:Generator_ColumnPropNameInRow="IdCliente" msprop:Generator_ColumnVarNameInTable="columnIdCliente" msprop:Generator_ColumnPropNameInTable="IdClienteColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Nome" msprop:Generator_UserColumnName="Nome" msprop:Generator_ColumnPropNameInRow="Nome" msprop:Generator_ColumnVarNameInTable="columnNome" msprop:Generator_ColumnPropNameInTable="NomeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Placa" msprop:Generator_UserColumnName="Placa" msprop:Generator_ColumnPropNameInRow="Placa" msprop:Generator_ColumnVarNameInTable="columnPlaca" msprop:Generator_ColumnPropNameInTable="PlacaColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Mensagem" msprop:Generator_UserColumnName="Mensagem" msprop:Generator_ColumnPropNameInRow="Mensagem" msprop:Generator_ColumnVarNameInTable="columnMensagem" msprop:Generator_ColumnPropNameInTable="MensagemColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="250" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ReterSaida" msprop:Generator_UserColumnName="ReterSaida" msprop:Generator_ColumnPropNameInRow="ReterSaida" msprop:Generator_ColumnVarNameInTable="columnReterSaida" msprop:Generator_ColumnPropNameInTable="ReterSaidaColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="ImpedirEntrada" msprop:Generator_UserColumnName="ImpedirEntrada" msprop:Generator_ColumnPropNameInRow="ImpedirEntrada" msprop:Generator_ColumnVarNameInTable="columnImpedirEntrada" msprop:Generator_ColumnPropNameInTable="ImpedirEntradaColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="ApenasComunicar" msprop:Generator_UserColumnName="ApenasComunicar" msprop:Generator_ColumnPropNameInRow="ApenasComunicar" msprop:Generator_ColumnVarNameInTable="columnApenasComunicar" msprop:Generator_ColumnPropNameInTable="ApenasComunicarColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="DataExec" msprop:Generator_UserColumnName="DataExec" msprop:Generator_ColumnPropNameInRow="DataExec" msprop:Generator_ColumnVarNameInTable="columnDataExec" msprop:Generator_ColumnPropNameInTable="DataExecColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="IdCabine" msprop:Generator_UserColumnName="IdCabine" msprop:Generator_ColumnPropNameInRow="IdCabine" msprop:Generator_ColumnVarNameInTable="columnIdCabine" msprop:Generator_ColumnPropNameInTable="IdCabineColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Cabine" msprop:Generator_UserColumnName="Cabine" msprop:Generator_ColumnPropNameInRow="Cabine" msprop:Generator_ColumnVarNameInTable="columnCabine" msprop:Generator_ColumnPropNameInTable="CabineColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="movimentos_financeiros_cabine" msprop:Generator_UserTableName="movimentos_financeiros_cabine" msprop:Generator_RowDeletedName="movimentos_financeiros_cabineRowDeleted" msprop:Generator_RowChangedName="movimentos_financeiros_cabineRowChanged" msprop:Generator_RowClassName="movimentos_financeiros_cabineRow" msprop:Generator_RowChangingName="movimentos_financeiros_cabineRowChanging" msprop:Generator_RowEvArgName="movimentos_financeiros_cabineRowChangeEvent" msprop:Generator_RowEvHandlerName="movimentos_financeiros_cabineRowChangeEventHandler" msprop:Generator_TableClassName="movimentos_financeiros_cabineDataTable" msprop:Generator_TableVarName="tablemovimentos_financeiros_cabine" msprop:Generator_RowDeletingName="movimentos_financeiros_cabineRowDeleting" msprop:Generator_TablePropName="movimentos_financeiros_cabine">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IdPatio" msprop:Generator_UserColumnName="IdPatio" msprop:Generator_ColumnPropNameInRow="IdPatio" msprop:Generator_ColumnVarNameInTable="columnIdPatio" msprop:Generator_ColumnPropNameInTable="IdPatioColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Patio" msprop:Generator_UserColumnName="Patio" msprop:Generator_ColumnPropNameInRow="Patio" msprop:Generator_ColumnVarNameInTable="columnPatio" msprop:Generator_ColumnPropNameInTable="PatioColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IdCabine" msprop:Generator_UserColumnName="IdCabine" msprop:Generator_ColumnPropNameInRow="IdCabine" msprop:Generator_ColumnVarNameInTable="columnIdCabine" msprop:Generator_ColumnPropNameInTable="IdCabineColumn" type="xs:int" />
              <xs:element name="Cabine" msprop:Generator_UserColumnName="Cabine" msprop:Generator_ColumnPropNameInRow="Cabine" msprop:Generator_ColumnVarNameInTable="columnCabine" msprop:Generator_ColumnPropNameInTable="CabineColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DataMov" msprop:Generator_UserColumnName="DataMov" msprop:Generator_ColumnPropNameInRow="DataMov" msprop:Generator_ColumnVarNameInTable="columnDataMov" msprop:Generator_ColumnPropNameInTable="DataMovColumn" type="xs:dateTime" />
              <xs:element name="Movimento" msprop:Generator_UserColumnName="Movimento" msprop:Generator_ColumnPropNameInRow="Movimento" msprop:Generator_ColumnVarNameInTable="columnMovimento" msprop:Generator_ColumnPropNameInTable="MovimentoColumn">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Credito" msprop:Generator_UserColumnName="Credito" msprop:Generator_ColumnPropNameInRow="Credito" msprop:Generator_ColumnVarNameInTable="columnCredito" msprop:Generator_ColumnPropNameInTable="CreditoColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="Debito" msprop:Generator_UserColumnName="Debito" msprop:Generator_ColumnPropNameInRow="Debito" msprop:Generator_ColumnVarNameInTable="columnDebito" msprop:Generator_ColumnPropNameInTable="DebitoColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="Saldo" msprop:Generator_UserColumnName="Saldo" msprop:Generator_ColumnPropNameInRow="Saldo" msprop:Generator_ColumnVarNameInTable="columnSaldo" msprop:Generator_ColumnPropNameInTable="SaldoColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="recebimento" msprop:Generator_UserTableName="recebimento" msprop:Generator_RowDeletedName="recebimentoRowDeleted" msprop:Generator_RowChangedName="recebimentoRowChanged" msprop:Generator_RowClassName="recebimentoRow" msprop:Generator_RowChangingName="recebimentoRowChanging" msprop:Generator_RowEvArgName="recebimentoRowChangeEvent" msprop:Generator_RowEvHandlerName="recebimentoRowChangeEventHandler" msprop:Generator_TableClassName="recebimentoDataTable" msprop:Generator_TableVarName="tablerecebimento" msprop:Generator_RowDeletingName="recebimentoRowDeleting" msprop:Generator_TablePropName="recebimento">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IdFormaPagamento" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="IdFormaPagamento" msprop:Generator_ColumnPropNameInRow="IdFormaPagamento" msprop:Generator_ColumnVarNameInTable="columnIdFormaPagamento" msprop:Generator_ColumnPropNameInTable="IdFormaPagamentoColumn" type="xs:int" minOccurs="0" />
              <xs:element name="FormaPagamento" msprop:Generator_UserColumnName="FormaPagamento" msprop:Generator_ColumnPropNameInRow="FormaPagamento" msprop:Generator_ColumnVarNameInTable="columnFormaPagamento" msprop:Generator_ColumnPropNameInTable="FormaPagamentoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Valor" msprop:Generator_UserColumnName="Valor" msprop:Generator_ColumnPropNameInRow="Valor" msprop:Generator_ColumnVarNameInTable="columnValor" msprop:Generator_ColumnPropNameInTable="ValorColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="ValorRec" msprop:Generator_UserColumnName="ValorRec" msprop:Generator_ColumnPropNameInRow="ValorRec" msprop:Generator_ColumnVarNameInTable="columnValorRec" msprop:Generator_ColumnPropNameInTable="ValorRecColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="recebimentoAberto" msprop:Generator_UserTableName="recebimentoAberto" msprop:Generator_RowDeletedName="recebimentoAbertoRowDeleted" msprop:Generator_RowChangedName="recebimentoAbertoRowChanged" msprop:Generator_RowClassName="recebimentoAbertoRow" msprop:Generator_RowChangingName="recebimentoAbertoRowChanging" msprop:Generator_RowEvArgName="recebimentoAbertoRowChangeEvent" msprop:Generator_RowEvHandlerName="recebimentoAbertoRowChangeEventHandler" msprop:Generator_TableClassName="recebimentoAbertoDataTable" msprop:Generator_TableVarName="tablerecebimentoAberto" msprop:Generator_RowDeletingName="recebimentoAbertoRowDeleting" msprop:Generator_TablePropName="recebimentoAberto">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IdRecebimento" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="IdRecebimento" msprop:Generator_ColumnPropNameInRow="IdRecebimento" msprop:Generator_ColumnVarNameInTable="columnIdRecebimento" msprop:Generator_ColumnPropNameInTable="IdRecebimentoColumn" type="xs:int" />
              <xs:element name="Recebimento" msprop:Generator_UserColumnName="Recebimento" msprop:Generator_ColumnPropNameInRow="Recebimento" msprop:Generator_ColumnVarNameInTable="columnRecebimento" msprop:Generator_ColumnPropNameInTable="RecebimentoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="70" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IdConvenio" msprop:Generator_UserColumnName="IdConvenio" msprop:Generator_ColumnPropNameInRow="IdConvenio" msprop:Generator_ColumnVarNameInTable="columnIdConvenio" msprop:Generator_ColumnPropNameInTable="IdConvenioColumn" type="xs:int" minOccurs="0" />
              <xs:element name="NomeConvenio" msprop:Generator_UserColumnName="NomeConvenio" msprop:Generator_ColumnPropNameInRow="NomeConvenio" msprop:Generator_ColumnVarNameInTable="columnNomeConvenio" msprop:Generator_ColumnPropNameInTable="NomeConvenioColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IdMensalista" msprop:Generator_UserColumnName="IdMensalista" msprop:Generator_ColumnPropNameInRow="IdMensalista" msprop:Generator_ColumnVarNameInTable="columnIdMensalista" msprop:Generator_ColumnPropNameInTable="IdMensalistaColumn" type="xs:int" minOccurs="0" />
              <xs:element name="NomeMensalista" msprop:Generator_UserColumnName="NomeMensalista" msprop:Generator_ColumnPropNameInRow="NomeMensalista" msprop:Generator_ColumnVarNameInTable="columnNomeMensalista" msprop:Generator_ColumnPropNameInTable="NomeMensalistaColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DtVencimento" msprop:Generator_UserColumnName="DtVencimento" msprop:Generator_ColumnPropNameInRow="DtVencimento" msprop:Generator_ColumnVarNameInTable="columnDtVencimento" msprop:Generator_ColumnPropNameInTable="DtVencimentoColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Valor" msprop:Generator_UserColumnName="Valor" msprop:Generator_ColumnPropNameInRow="Valor" msprop:Generator_ColumnVarNameInTable="columnValor" msprop:Generator_ColumnPropNameInTable="ValorColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="recebimentoConvenio" msprop:Generator_UserTableName="recebimentoConvenio" msprop:Generator_RowDeletedName="recebimentoConvenioRowDeleted" msprop:Generator_RowChangedName="recebimentoConvenioRowChanged" msprop:Generator_RowClassName="recebimentoConvenioRow" msprop:Generator_RowChangingName="recebimentoConvenioRowChanging" msprop:Generator_RowEvArgName="recebimentoConvenioRowChangeEvent" msprop:Generator_RowEvHandlerName="recebimentoConvenioRowChangeEventHandler" msprop:Generator_TableClassName="recebimentoConvenioDataTable" msprop:Generator_TableVarName="tablerecebimentoConvenio" msprop:Generator_RowDeletingName="recebimentoConvenioRowDeleting" msprop:Generator_TablePropName="recebimentoConvenio">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IdRecebimento" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="IdRecebimento" msprop:Generator_ColumnPropNameInRow="IdRecebimento" msprop:Generator_ColumnVarNameInTable="columnIdRecebimento" msprop:Generator_ColumnPropNameInTable="IdRecebimentoColumn" type="xs:int" />
              <xs:element name="Recebimento" msprop:Generator_UserColumnName="Recebimento" msprop:Generator_ColumnPropNameInRow="Recebimento" msprop:Generator_ColumnVarNameInTable="columnRecebimento" msprop:Generator_ColumnPropNameInTable="RecebimentoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="70" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IdConvenio" msprop:Generator_UserColumnName="IdConvenio" msprop:Generator_ColumnPropNameInRow="IdConvenio" msprop:Generator_ColumnVarNameInTable="columnIdConvenio" msprop:Generator_ColumnPropNameInTable="IdConvenioColumn" type="xs:int" minOccurs="0" />
              <xs:element name="NomeConvenio" msprop:Generator_UserColumnName="NomeConvenio" msprop:Generator_ColumnPropNameInRow="NomeConvenio" msprop:Generator_ColumnVarNameInTable="columnNomeConvenio" msprop:Generator_ColumnPropNameInTable="NomeConvenioColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DtVencimento" msprop:Generator_UserColumnName="DtVencimento" msprop:Generator_ColumnPropNameInRow="DtVencimento" msprop:Generator_ColumnVarNameInTable="columnDtVencimento" msprop:Generator_ColumnPropNameInTable="DtVencimentoColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Valor" msprop:Generator_UserColumnName="Valor" msprop:Generator_ColumnPropNameInRow="Valor" msprop:Generator_ColumnVarNameInTable="columnValor" msprop:Generator_ColumnPropNameInTable="ValorColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="DtPagamento" msprop:Generator_UserColumnName="DtPagamento" msprop:Generator_ColumnPropNameInRow="DtPagamento" msprop:Generator_ColumnVarNameInTable="columnDtPagamento" msprop:Generator_ColumnPropNameInTable="DtPagamentoColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="IdFormaPagamento" msprop:Generator_UserColumnName="IdFormaPagamento" msprop:Generator_ColumnPropNameInRow="IdFormaPagamento" msprop:Generator_ColumnVarNameInTable="columnIdFormaPagamento" msprop:Generator_ColumnPropNameInTable="IdFormaPagamentoColumn" type="xs:int" minOccurs="0" />
              <xs:element name="FormaPagamento" msprop:Generator_UserColumnName="FormaPagamento" msprop:Generator_ColumnPropNameInRow="FormaPagamento" msprop:Generator_ColumnVarNameInTable="columnFormaPagamento" msprop:Generator_ColumnPropNameInTable="FormaPagamentoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ValorRec" msprop:Generator_UserColumnName="ValorRec" msprop:Generator_ColumnPropNameInRow="ValorRec" msprop:Generator_ColumnVarNameInTable="columnValorRec" msprop:Generator_ColumnPropNameInTable="ValorRecColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="recebimentoMensalista" msprop:Generator_UserTableName="recebimentoMensalista" msprop:Generator_RowDeletedName="recebimentoMensalistaRowDeleted" msprop:Generator_RowChangedName="recebimentoMensalistaRowChanged" msprop:Generator_RowClassName="recebimentoMensalistaRow" msprop:Generator_RowChangingName="recebimentoMensalistaRowChanging" msprop:Generator_RowEvArgName="recebimentoMensalistaRowChangeEvent" msprop:Generator_RowEvHandlerName="recebimentoMensalistaRowChangeEventHandler" msprop:Generator_TableClassName="recebimentoMensalistaDataTable" msprop:Generator_TableVarName="tablerecebimentoMensalista" msprop:Generator_RowDeletingName="recebimentoMensalistaRowDeleting" msprop:Generator_TablePropName="recebimentoMensalista">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IdRecebimento" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="IdRecebimento" msprop:Generator_ColumnPropNameInRow="IdRecebimento" msprop:Generator_ColumnVarNameInTable="columnIdRecebimento" msprop:Generator_ColumnPropNameInTable="IdRecebimentoColumn" type="xs:int" />
              <xs:element name="Recebimento" msprop:Generator_UserColumnName="Recebimento" msprop:Generator_ColumnPropNameInRow="Recebimento" msprop:Generator_ColumnVarNameInTable="columnRecebimento" msprop:Generator_ColumnPropNameInTable="RecebimentoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="70" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DtVencimento" msprop:Generator_UserColumnName="DtVencimento" msprop:Generator_ColumnPropNameInRow="DtVencimento" msprop:Generator_ColumnVarNameInTable="columnDtVencimento" msprop:Generator_ColumnPropNameInTable="DtVencimentoColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Valor" msprop:Generator_UserColumnName="Valor" msprop:Generator_ColumnPropNameInRow="Valor" msprop:Generator_ColumnVarNameInTable="columnValor" msprop:Generator_ColumnPropNameInTable="ValorColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="DtPagamento" msprop:Generator_UserColumnName="DtPagamento" msprop:Generator_ColumnPropNameInRow="DtPagamento" msprop:Generator_ColumnVarNameInTable="columnDtPagamento" msprop:Generator_ColumnPropNameInTable="DtPagamentoColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="IdFormaPagamento" msprop:Generator_UserColumnName="IdFormaPagamento" msprop:Generator_ColumnPropNameInRow="IdFormaPagamento" msprop:Generator_ColumnVarNameInTable="columnIdFormaPagamento" msprop:Generator_ColumnPropNameInTable="IdFormaPagamentoColumn" type="xs:int" minOccurs="0" />
              <xs:element name="FormaPagamento" msprop:Generator_UserColumnName="FormaPagamento" msprop:Generator_ColumnPropNameInRow="FormaPagamento" msprop:Generator_ColumnVarNameInTable="columnFormaPagamento" msprop:Generator_ColumnPropNameInTable="FormaPagamentoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ValorRec" msprop:Generator_UserColumnName="ValorRec" msprop:Generator_ColumnPropNameInRow="ValorRec" msprop:Generator_ColumnVarNameInTable="columnValorRec" msprop:Generator_ColumnPropNameInTable="ValorRecColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="IdMensalista" msprop:Generator_UserColumnName="IdMensalista" msprop:Generator_ColumnPropNameInRow="IdMensalista" msprop:Generator_ColumnVarNameInTable="columnIdMensalista" msprop:Generator_ColumnPropNameInTable="IdMensalistaColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Nome" msprop:Generator_UserColumnName="Nome" msprop:Generator_ColumnPropNameInRow="Nome" msprop:Generator_ColumnVarNameInTable="columnNome" msprop:Generator_ColumnPropNameInTable="NomeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="recebimentoDiversos" msprop:Generator_UserTableName="recebimentoDiversos" msprop:Generator_RowDeletedName="recebimentoDiversosRowDeleted" msprop:Generator_RowChangedName="recebimentoDiversosRowChanged" msprop:Generator_RowClassName="recebimentoDiversosRow" msprop:Generator_RowChangingName="recebimentoDiversosRowChanging" msprop:Generator_RowEvArgName="recebimentoDiversosRowChangeEvent" msprop:Generator_RowEvHandlerName="recebimentoDiversosRowChangeEventHandler" msprop:Generator_TableClassName="recebimentoDiversosDataTable" msprop:Generator_TableVarName="tablerecebimentoDiversos" msprop:Generator_RowDeletingName="recebimentoDiversosRowDeleting" msprop:Generator_TablePropName="recebimentoDiversos">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IdRecebimento" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="IdRecebimento" msprop:Generator_ColumnPropNameInRow="IdRecebimento" msprop:Generator_ColumnVarNameInTable="columnIdRecebimento" msprop:Generator_ColumnPropNameInTable="IdRecebimentoColumn" type="xs:int" />
              <xs:element name="Recebimento" msprop:Generator_UserColumnName="Recebimento" msprop:Generator_ColumnPropNameInRow="Recebimento" msprop:Generator_ColumnVarNameInTable="columnRecebimento" msprop:Generator_ColumnPropNameInTable="RecebimentoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="70" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Valor" msprop:Generator_UserColumnName="Valor" msprop:Generator_ColumnPropNameInRow="Valor" msprop:Generator_ColumnVarNameInTable="columnValor" msprop:Generator_ColumnPropNameInTable="ValorColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="IdFormaPagamento" msprop:Generator_UserColumnName="IdFormaPagamento" msprop:Generator_ColumnPropNameInRow="IdFormaPagamento" msprop:Generator_ColumnVarNameInTable="columnIdFormaPagamento" msprop:Generator_ColumnPropNameInTable="IdFormaPagamentoColumn" type="xs:int" minOccurs="0" />
              <xs:element name="FormaPagamento" msprop:Generator_UserColumnName="FormaPagamento" msprop:Generator_ColumnPropNameInRow="FormaPagamento" msprop:Generator_ColumnVarNameInTable="columnFormaPagamento" msprop:Generator_ColumnPropNameInTable="FormaPagamentoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ValorRec" msprop:Generator_UserColumnName="ValorRec" msprop:Generator_ColumnPropNameInRow="ValorRec" msprop:Generator_ColumnVarNameInTable="columnValorRec" msprop:Generator_ColumnPropNameInTable="ValorRecColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="Qtde" msprop:Generator_UserColumnName="Qtde" msprop:Generator_ColumnPropNameInRow="Qtde" msprop:Generator_ColumnVarNameInTable="columnQtde" msprop:Generator_ColumnPropNameInTable="QtdeColumn" type="xs:long" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="pagamento" msprop:Generator_UserTableName="pagamento" msprop:Generator_RowDeletedName="pagamentoRowDeleted" msprop:Generator_RowChangedName="pagamentoRowChanged" msprop:Generator_RowClassName="pagamentoRow" msprop:Generator_RowChangingName="pagamentoRowChanging" msprop:Generator_RowEvArgName="pagamentoRowChangeEvent" msprop:Generator_RowEvHandlerName="pagamentoRowChangeEventHandler" msprop:Generator_TableClassName="pagamentoDataTable" msprop:Generator_TableVarName="tablepagamento" msprop:Generator_RowDeletingName="pagamentoRowDeleting" msprop:Generator_TablePropName="pagamento">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IdPagamento" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="IdPagamento" msprop:Generator_ColumnPropNameInRow="IdPagamento" msprop:Generator_ColumnVarNameInTable="columnIdPagamento" msprop:Generator_ColumnPropNameInTable="IdPagamentoColumn" type="xs:int" />
              <xs:element name="Pagamento" msprop:Generator_UserColumnName="Pagamento" msprop:Generator_ColumnPropNameInRow="Pagamento" msprop:Generator_ColumnVarNameInTable="columnPagamento" msprop:Generator_ColumnPropNameInTable="PagamentoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="70" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DtVencimento" msprop:Generator_UserColumnName="DtVencimento" msprop:Generator_ColumnPropNameInRow="DtVencimento" msprop:Generator_ColumnVarNameInTable="columnDtVencimento" msprop:Generator_ColumnPropNameInTable="DtVencimentoColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="DtPagamento" msprop:Generator_UserColumnName="DtPagamento" msprop:Generator_ColumnPropNameInRow="DtPagamento" msprop:Generator_ColumnVarNameInTable="columnDtPagamento" msprop:Generator_ColumnPropNameInTable="DtPagamentoColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="IdFormaPagamento" msprop:Generator_UserColumnName="IdFormaPagamento" msprop:Generator_ColumnPropNameInRow="IdFormaPagamento" msprop:Generator_ColumnVarNameInTable="columnIdFormaPagamento" msprop:Generator_ColumnPropNameInTable="IdFormaPagamentoColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Valor" msprop:Generator_UserColumnName="Valor" msprop:Generator_ColumnPropNameInRow="Valor" msprop:Generator_ColumnVarNameInTable="columnValor" msprop:Generator_ColumnPropNameInTable="ValorColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="ValorPago" msprop:Generator_UserColumnName="ValorPago" msprop:Generator_ColumnPropNameInRow="ValorPago" msprop:Generator_ColumnVarNameInTable="columnValorPago" msprop:Generator_ColumnPropNameInTable="ValorPagoColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="FormaPagamento" msprop:Generator_UserColumnName="FormaPagamento" msprop:Generator_ColumnPropNameInRow="FormaPagamento" msprop:Generator_ColumnVarNameInTable="columnFormaPagamento" msprop:Generator_ColumnPropNameInTable="FormaPagamentoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="pagamentoAberto" msprop:Generator_UserTableName="pagamentoAberto" msprop:Generator_RowDeletedName="pagamentoAbertoRowDeleted" msprop:Generator_RowChangedName="pagamentoAbertoRowChanged" msprop:Generator_RowClassName="pagamentoAbertoRow" msprop:Generator_RowChangingName="pagamentoAbertoRowChanging" msprop:Generator_RowEvArgName="pagamentoAbertoRowChangeEvent" msprop:Generator_RowEvHandlerName="pagamentoAbertoRowChangeEventHandler" msprop:Generator_TableClassName="pagamentoAbertoDataTable" msprop:Generator_TableVarName="tablepagamentoAberto" msprop:Generator_RowDeletingName="pagamentoAbertoRowDeleting" msprop:Generator_TablePropName="pagamentoAberto">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IdPagamento" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="IdPagamento" msprop:Generator_ColumnPropNameInRow="IdPagamento" msprop:Generator_ColumnVarNameInTable="columnIdPagamento" msprop:Generator_ColumnPropNameInTable="IdPagamentoColumn" type="xs:int" />
              <xs:element name="Pagamento" msprop:Generator_UserColumnName="Pagamento" msprop:Generator_ColumnPropNameInRow="Pagamento" msprop:Generator_ColumnVarNameInTable="columnPagamento" msprop:Generator_ColumnPropNameInTable="PagamentoColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="70" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DtVencimento" msprop:Generator_UserColumnName="DtVencimento" msprop:Generator_ColumnPropNameInRow="DtVencimento" msprop:Generator_ColumnVarNameInTable="columnDtVencimento" msprop:Generator_ColumnPropNameInTable="DtVencimentoColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="Valor" msprop:Generator_UserColumnName="Valor" msprop:Generator_ColumnPropNameInRow="Valor" msprop:Generator_ColumnVarNameInTable="columnValor" msprop:Generator_ColumnPropNameInTable="ValorColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="pendenciaAberto" msprop:Generator_UserTableName="pendenciaAberto" msprop:Generator_RowDeletedName="pendenciaAbertoRowDeleted" msprop:Generator_TableClassName="pendenciaAbertoDataTable" msprop:Generator_RowChangedName="pendenciaAbertoRowChanged" msprop:Generator_RowClassName="pendenciaAbertoRow" msprop:Generator_RowChangingName="pendenciaAbertoRowChanging" msprop:Generator_RowEvArgName="pendenciaAbertoRowChangeEvent" msprop:Generator_RowEvHandlerName="pendenciaAbertoRowChangeEventHandler" msprop:Generator_TablePropName="pendenciaAberto" msprop:Generator_TableVarName="tablependenciaAberto" msprop:Generator_RowDeletingName="pendenciaAbertoRowDeleting">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="IdPendencia" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_UserColumnName="IdPendencia" msprop:Generator_ColumnPropNameInRow="IdPendencia" msprop:Generator_ColumnVarNameInTable="columnIdPendencia" msprop:Generator_ColumnPropNameInTable="IdPendenciaColumn" type="xs:int" />
              <xs:element name="Pendencia" msprop:Generator_UserColumnName="Pendencia" msprop:Generator_ColumnPropNameInRow="Pendencia" msprop:Generator_ColumnVarNameInTable="columnPendencia" msprop:Generator_ColumnPropNameInTable="PendenciaColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="70" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="IdOperador" msprop:Generator_UserColumnName="IdOperador" msprop:Generator_ColumnPropNameInRow="IdOperador" msprop:Generator_ColumnVarNameInTable="columnIdOperador" msprop:Generator_ColumnPropNameInTable="IdOperadorColumn" type="xs:int" minOccurs="0" />
              <xs:element name="Nome" msprop:Generator_UserColumnName="Nome" msprop:Generator_ColumnPropNameInRow="Nome" msprop:Generator_ColumnVarNameInTable="columnNome" msprop:Generator_ColumnPropNameInTable="NomeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="45" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Placa" msprop:Generator_UserColumnName="Placa" msprop:Generator_ColumnPropNameInRow="Placa" msprop:Generator_ColumnVarNameInTable="columnPlaca" msprop:Generator_ColumnPropNameInTable="PlacaColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Valor" msprop:Generator_UserColumnName="Valor" msprop:Generator_ColumnPropNameInRow="Valor" msprop:Generator_ColumnVarNameInTable="columnValor" msprop:Generator_ColumnPropNameInTable="ValorColumn" type="xs:decimal" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:alertas_pendentes" />
      <xs:field xpath="mstns:IdAlerta" />
    </xs:unique>
    <xs:unique name="alertas_executados_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:alertas_executados" />
      <xs:field xpath="mstns:IdAlerta" />
    </xs:unique>
    <xs:unique name="movimentos_financeiros_cabine_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:movimentos_financeiros_cabine" />
      <xs:field xpath="mstns:IdCabine" />
      <xs:field xpath="mstns:DataMov" />
      <xs:field xpath="mstns:Movimento" />
    </xs:unique>
    <xs:unique name="recebimento_Constraint1" msdata:ConstraintName="Constraint1">
      <xs:selector xpath=".//mstns:recebimento" />
      <xs:field xpath="mstns:IdFormaPagamento" />
    </xs:unique>
    <xs:unique name="recebimentoAberto_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:recebimentoAberto" />
      <xs:field xpath="mstns:IdRecebimento" />
    </xs:unique>
    <xs:unique name="recebimentoConvenio_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:recebimentoConvenio" />
      <xs:field xpath="mstns:IdRecebimento" />
    </xs:unique>
    <xs:unique name="recebimentoMensalista_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:recebimentoMensalista" />
      <xs:field xpath="mstns:IdRecebimento" />
    </xs:unique>
    <xs:unique name="recebimentoDiversos_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:recebimentoDiversos" />
      <xs:field xpath="mstns:IdRecebimento" />
    </xs:unique>
    <xs:unique name="pagamento_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:pagamento" />
      <xs:field xpath="mstns:IdPagamento" />
    </xs:unique>
    <xs:unique name="pagamentoAberto_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:pagamentoAberto" />
      <xs:field xpath="mstns:IdPagamento" />
    </xs:unique>
    <xs:unique name="pendenciaAberto_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:pendenciaAberto" />
      <xs:field xpath="mstns:IdPendencia" />
    </xs:unique>
  </xs:element>
</xs:schema>